In SAS Financial Management, you can delete transactions using the fm_3000_delete_fact_data job in SAS Data Integration Studio or using user-written code that calls the %ETLDLFCT macro to delete facts from a cycle.

When you use the jobs in SAS Data Integration Studio or user-written code, you must specify the dimension member selection list to use in selecting which transactions to delete. Here is an example:

It is important to note that the observations in this table must be in dimension type order as shown above.

If the dimension member selection table contains observations that are not sorted by dimension type, as shown in the following example, the existing fact records for these crossing might not be deleted.

To correct this problem, unzip this file and extract the contents to the relevant location:

Operating System and Release Information